SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO


CREATE PROCEDURE [dbo].[usp_GetTopTenRequire]
AS 
    SELECT TOP ( 10 )
            b.JOL_Employer_Name,
            a.JOL_Require_ID,
            a.JOL_Require_Company,
            a.JOL_Require_Job,
            a.JOL_Require_VerifyStatus,
            a.JOL_Require_ClickNumber,
            a.JOL_Require_AddTime
    FROM    dbo.JOL_Require AS a
            INNER JOIN dbo.JOL_Employer AS b ON a.JOL_Require_Company = b.JOL_Employer_Account
    ORDER BY JOL_Require_AddTime DESC,
            JOL_Require_UpdateTime DESC


GO
